package com.china08.yxyapi.entity.db.huodong.template;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;

import com.china08.yxyapi.entity.BaseEntity;

/**
 * 备课包大赛统计 </br>
 * 在yw中需要查询 , yx 的学校信息, 可以先在本表中查询是否有数据,然后进行更新.
 */
@SuppressWarnings("serial")
@Entity
@Table(name = "yxy_huodong_resource_template", catalog = "yxy_huodong", uniqueConstraints = @UniqueConstraint(columnNames = {
		"type", "sws_url", "year" }))
public class YxyHuodongResourceTemplate extends BaseEntity {

	@Column(name = "type", columnDefinition = "varchar(6) comment '活动类型:00--备授课活动' ")
	private String type;

	@Column(name = "sws_url", columnDefinition = "varchar(128) comment '域名地址' ")
	private String swsUrl;

	@Column(name = "year", columnDefinition = "int comment '年度' ")
	private Integer year;

	/**
	 * 学校id
	 */
	@Column(columnDefinition = "varchar(32) comment '学校id' ")
	private String schoolId;

	/**
	 * 学校名称
	 */
	@Column(name = "school_nick", columnDefinition = "varchar(128) comment 'school name' ")
	private String schoolNick;

	/** 行政区域:省ID */
	@Column(name = "area_id_province", columnDefinition = "varchar(6) comment 'province code of school' ")
	private String areaIdProvince;

	/** 行政区域:省ID */
	@Column(name = "area_name_province", columnDefinition = "varchar(32) comment 'province name of school ' ")
	private String areaNameProvince;

	/** 行政区域:市ID */
	@Column(name = "area_id_city", columnDefinition = "varchar(32) comment 'city code of school ' ")
	private String areaIdCity;

	/** 行政区域:市ID */
	@Column(name = "area_name_city", columnDefinition = "varchar(32) comment 'city name of school ' ")
	private String areaNameCity;

	/** 行政区域:区县ID */
	@Column(name = "area_id_district", columnDefinition = "varchar(32) comment 'district code of school ' ")
	private String areaIdDistrict;

	/** 行政区域:区县ID */
	@Column(name = "area_name_district", columnDefinition = "varchar(32) comment 'district name of school ' ")
	private String areaNameDistrict;

	@Column(columnDefinition = "datetime comment '开始时间' ")
	private Date beginDate;

	@Column(columnDefinition = "datetime comment '结束时间' ")
	private Date endDate;

	@Column(columnDefinition = "varchar(128) comment '活动目标' ")
	private String target;

	@Column(columnDefinition = "varchar(128) comment '要求' ")
	private String request;

	@Column(columnDefinition = "varchar(128) comment '操作流程' ")
	private String operationFlow;

	@Column(columnDefinition = "varchar(128) comment '操作流程视频' ")
	private String operationVideo;

	@Column(columnDefinition = "varchar(128) comment '附件1' ")
	private String accessory1;

	@Column(columnDefinition = "varchar(128) comment '附件2' ")
	private String accessory2;

	@Column(columnDefinition = "varchar(128) comment '附件3' ")
	private String accessory3;

	@Column(columnDefinition = "varchar(128) comment '附件4' ")
	private String accessory4;

	@Column(columnDefinition = "varchar(128) comment '附件5' ")
	private String accessory5;

	@Column(columnDefinition = "varchar(128) comment '附件6' ")
	private String accessory6;

	@Column(columnDefinition = "tinyint(1) default 1 comment '状态 1--有效, 0--无效' ")
	private Integer status = 1;

}
